Add a column

ALTER TABLE tablename MODIFY( columname DATATYPE(NUMBER));

Description

Creates a new column on an existing table

Arguments

String tablename

The name of the table you want to add a column to.

String column_name

The name of the column(s) you want to add to the table.

Datatype DATATYPE

The type of data that should be stored ie NUMBER, DATE, VARCHAR etc.

Examples

Example 1

Adds a column with a not null so the value must be filled

ALTER TABLE users MODIFY(
lastname VARCHAR(30) NOT NULL);